<!doctype HTML public "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- Click to Convert 5.2: Anything to HTML -->
<!-- http://www.clicktoconvert.com -->

<html>
<head>
<title>gravityboxscheduleuserguide - page 59 of 234</title>
<meta http-equiv=content-type content=text/html;charset=iso-8859-1>
<meta name="Generator" content="Click to Convert">

<!--Start of page styles-->
<STYLE TYPE="text/css">
<!--
 /* Foreground Image Styles */

 /* Position Styles */
 .ts59p0{position:absolute;left:106px;top:97px;}
 .ts59p1{position:absolute;left:352px;top:97px;}
 .ts59p3{position:absolute;left:672px;top:97px;}
 .ts59p7{position:absolute;left:106px;top:113px;}
 .ts59p8{position:absolute;left:706px;top:1026px;}
 .ts59p9{position:absolute;left:331px;top:1044px;}
 .ts59p13{position:absolute;left:106px;top:146px;}
 .ts59p14{position:absolute;left:106px;top:165px;}
 .ts59p16{position:absolute;left:106px;top:184px;}
 .ts59p17{position:absolute;left:106px;top:202px;}
 .ts59p19{position:absolute;left:106px;top:220px;}
 .ts59p21{position:absolute;left:106px;top:238px;}
 .ts59p23{position:absolute;left:106px;top:256px;}
 .ts59p26{position:absolute;left:106px;top:274px;}
 .ts59p27{position:absolute;left:106px;top:292px;}
 .ts59p29{position:absolute;left:106px;top:310px;}
 .ts59p31{position:absolute;left:106px;top:329px;}
 .ts59p33{position:absolute;left:106px;top:347px;}
 .ts59p35{position:absolute;left:106px;top:365px;}
 .ts59p37{position:absolute;left:106px;top:383px;}
 .ts59p39{position:absolute;left:106px;top:401px;}
 .ts59p41{position:absolute;left:106px;top:419px;}
 .ts59p44{position:absolute;left:106px;top:437px;}
 .ts59p46{position:absolute;left:106px;top:455px;}
 .ts59p47{position:absolute;left:106px;top:474px;}
 .ts59p49{position:absolute;left:106px;top:492px;}
 .ts59p51{position:absolute;left:106px;top:510px;}
 .ts59p53{position:absolute;left:106px;top:528px;}
 .ts59p55{position:absolute;left:106px;top:546px;}
 .ts59p57{position:absolute;left:106px;top:564px;}
 .ts59p60{position:absolute;left:106px;top:582px;}
 .ts59p62{position:absolute;left:106px;top:600px;}
 .ts59p64{position:absolute;left:106px;top:619px;}
 .ts59p66{position:absolute;left:106px;top:637px;}
 .ts59p68{position:absolute;left:106px;top:655px;}
 .ts59p70{position:absolute;left:106px;top:673px;}
 .ts59p72{position:absolute;left:106px;top:691px;}
 .ts59p73{position:absolute;left:106px;top:710px;}
 .ts59p74{position:absolute;left:106px;top:728px;}
 .ts59p76{position:absolute;left:106px;top:747px;}
 .ts59p77{position:absolute;left:106px;top:765px;}
 .ts59p78{position:absolute;left:154px;top:765px;}
 .ts59p80{position:absolute;left:106px;top:783px;}
 .ts59p81{position:absolute;left:106px;top:802px;}
 .ts59p82{position:absolute;left:106px;top:820px;}
 .ts59p84{position:absolute;left:106px;top:839px;}
 .ts59p86{position:absolute;left:106px;top:857px;}
 .ts59p87{position:absolute;left:106px;top:876px;}
 .ts59p89{position:absolute;left:106px;top:894px;}
 .ts59p90{position:absolute;left:106px;top:913px;}
 .ts59p92{position:absolute;left:106px;top:931px;}
 .ts59p93{position:absolute;left:106px;top:949px;}
 .ts59p95{position:absolute;left:106px;top:967px;}
 .ts59p97{position:absolute;left:106px;top:985px;}

 /* Font Styles */
 .ft0p59{font-style:normal;font-weight:bold;font-size:13px;font-family:arial,sans-serif;color:#000000;}
 .ft1p59{font-weight:normal;}
 .ft2p59{font-style:normal;font-weight:normal;font-size:13px;font-family:"times new roman","times new roman",times,serif;color:#000000;}
 .ft3p59{font-style:normal;font-weight:normal;font-size:16px;font-family:"times new roman","times new roman",times,serif;color:#000000;}
 .ft4p59{font-style:normal;font-weight:bold;font-size:11px;font-family:arial,sans-serif;color:#000000;}
 .ft5p59{font-style:normal;font-weight:normal;font-size:16px;font-family:arial,sans-serif;color:#000000;}
 .ft6p59{font-style:normal;font-weight:normal;font-size:16px;font-family:"courier new",courier,monospace;color:#000000;}

 /* Background Style */
 .styleBackground59{position:absolute;left:97px;top:163px}

 /* Navigation Styles */
 .styleNavBarTop{position:absolute;left:0px;top:2px}
 .nb{position:absolute;left:2px;top:0px}
 .nbs{position:absolute;left:0px;top:0px}
 .nbe{position:absolute;left:836px;top:0px}
 .styleNavBarBot{position:absolute;left:0px;top:1117px}
-->
</STYLE>
<!--End of page styles-->

</head>
<body bgcolor="#ffffff" text="#000000" link="#0000FF" Vlink="#660099">

<table id="pageTable" width="836" STYLE="position: relative; left: auto; top: auto;"><tr><td>
<div class=nbs><img src="./navbarstart.gif" width="2" height="30"></div>
<div class=nb><img src="./navbar.gif" width="836" height="30" alt="Navigation bar"></div>
<div class=nbe><img src="./navbarend.gif" width="2" height="30"></div>
<div class=styleNavBarTop>
<table width="834" height="26" border="0" cellspacing="0">
  <tr align="left">
    <td width="4">&nbsp;</td>
    <td width="25" align="center"><a href="http://www.gravitybox.com" target="_parent"><img src="./home.gif" border="0" alt="Home"></a></td>
    <td width="25" align="center"><a href="#" onClick="window.open('./print.html','Printing','width=300,height=100,toolbar=no,directories=no');return false;"><img src="./print.gif" border="0" alt="Print document"></a></td>
    <td width="10" align="center"><img src="./separator.gif" border="0"></td>
    <td width="18" align="center"><a href="./index1.html"><img src="./start.gif" width="18" height="14" border="0" alt="Start"></a></td>
    <td width="18" align="center"><a href="./index58.html"><img src="./back.gif" width="14" height="14" border="0" alt="Previous page"></a></td>
    <td width="80" valign="middle"><table width="100%" height="16" border="0" cellspacing="1" bgcolor="#ACA899"><tr><td align="center" bgcolor="#ffffff"><font face=verdana,arial,sans-serif><font size="1">&nbsp;59 of 234&nbsp;</font></font></td></tr></table></td>
    <td width="18" align="center"><a href="./index60.html"><img src="./forward.gif" width="14" height="14" border="0" alt="Next page"></a></td>
    <td width="18" align="center"><a href="./index234.html"><img src="./end.gif" width="18" height="14" border="0" alt="End"></a></td>
    <td width="620">&nbsp;</td>
  </tr>
</table>
<p>
</div>
<nobr>
<div class=styleBackground59><img src="./background59.png" width="633" height="892" border="0" alt=""></div>
<div class=ts59p0><span class="ft0p59"> </span></div>
<div class=ts59p1><span class="ft0p59">Gravitybox Schedule Primer<span class="ft1p59"> </span></span></div>
<div class=ts59p3><span class="ft0p59">Page 57&nbsp; </span></div>
<div class=ts59p7><span class="ft2p59"> </span></div>
<div class=ts59p8><span class="ft3p59"> </span></div>
<div class=ts59p9><span class="ft4p59">1998&#45;2004 Gravitybox Software LLC<span class="ft3p59"> </span></span></div>
<div class=ts59p13><span class="ft5p59"> </span></div>
<div class=ts59p14><span class="ft6p59">Private Sub LoadSchedule() </span></div>
<div class=ts59p16><span class="ft6p59"> </span></div>
<div class=ts59p17><span class="ft6p59">'This procedure Loads a Schedule from the database </span></div>
<div class=ts59p19><span class="ft6p59">'and populates this form. This method assumes a&nbsp; </span></div>
<div class=ts59p21><span class="ft6p59">'database with a table named &#147;tbl_Schedule&#148; and </span></div>
<div class=ts59p23><span class="ft6p59">'also a schedule control named &#147;Schedule1&#148; </span></div>
<div class=ts59p26><span class="ft6p59"> </span></div>
<div class=ts59p27><span class="ft6p59">Dim Db As ADODB.Connection </span></div>
<div class=ts59p29><span class="ft6p59">Dim rs As ADODB.Recordset </span></div>
<div class=ts59p31><span class="ft6p59">&nbsp;&nbsp; </span></div>
<div class=ts59p33><span class="ft6p59">&nbsp; 'Load this day's information from the Database </span></div>
<div class=ts59p35><span class="ft6p59">&nbsp; Set Db = New ADODB.Connection </span></div>
<div class=ts59p37><span class="ft6p59">&nbsp; Db.ConnectionString = GetConnectString &#38; _ </span></div>
<div class=ts59p39><span class="ft6p59">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AppPath &#38; &#34;schedule.mdb&#34; </span></div>
<div class=ts59p41><span class="ft6p59">&nbsp; Call Db.Open </span></div>
<div class=ts59p44><span class="ft6p59">&nbsp; Set rs = New ADODB.Recordset </span></div>
<div class=ts59p46><span class="ft6p59">&nbsp; Set rs = Db.Execute(&#34;select * from tbl_Schedule where </span></div>
<div class=ts59p47><span class="ft6p59">StartDate = #1/1/2002#&#34;) </span></div>
<div class=ts59p49><span class="ft6p59">&nbsp;&nbsp; </span></div>
<div class=ts59p51><span class="ft6p59">&nbsp; 'Loop through and display all the appointments </span></div>
<div class=ts59p53><span class="ft6p59">&nbsp; While Not rs.EOF </span></div>
<div class=ts59p55><span class="ft6p59">&nbsp;&nbsp;&nbsp; Call Me.Schedule1.ScheduleItems.Add(&#34;&#34;, _ </span></div>
<div class=ts59p57><span class="ft6p59">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #1/1/2002#, rs!RoomName, _ </span></div>
<div class=ts59p60><span class="ft6p59">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs!StartTime, rs!Length, _ </span></div>
<div class=ts59p62><span class="ft6p59">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rs!Description, rs!CategoryName &#38; &#34;&#34;) </span></div>
<div class=ts59p64><span class="ft6p59">&nbsp;&nbsp;&nbsp; Call rs.MoveNext </span></div>
<div class=ts59p66><span class="ft6p59">&nbsp; Wend </span></div>
<div class=ts59p68><span class="ft6p59">&nbsp;&nbsp; </span></div>
<div class=ts59p70><span class="ft6p59">End Sub<span class="ft5p59"> </span></span></div>
<div class=ts59p72><span class="ft5p59"> </span></div>
<div class=ts59p73><span class="ft5p59">This code will load the all of the appointments that have been scheduled for this </span></div>
<div class=ts59p74><span class="ft5p59">particular date. </span></div>
<div class=ts59p76><span class="ft5p59"> </span></div>
<div class=ts59p77><span class="ft5p59"> </span></div>
<div class=ts59p78><span class="ft5p59">Before the appointments are loaded, there is code to load the rooms and </span></div>
<div class=ts59p80><span class="ft5p59">categories of the schedule. This is necessary for the schedule is display correctly, of </span></div>
<div class=ts59p81><span class="ft5p59">course. The rooms are loaded from the database where they have been previously </span></div>
<div class=ts59p82><span class="ft5p59">setup from the room configuration screen. That screen allows the user to specify a </span></div>
<div class=ts59p84><span class="ft5p59">number of rooms and a name for each. </span></div>
<div class=ts59p86><span class="ft5p59"> </span></div>
<div class=ts59p87><span class="ft6p59">Private Sub LoadRooms() </span></div>
<div class=ts59p89><span class="ft6p59"> </span></div>
<div class=ts59p90><span class="ft6p59">'This procedure Loads a Schedule from the database </span></div>
<div class=ts59p92><span class="ft6p59"> </span></div>
<div class=ts59p93><span class="ft6p59">Dim Db As ADODB.Connection </span></div>
<div class=ts59p95><span class="ft6p59">Dim rs As ADODB.Recordset </span></div>
<div class=ts59p97><span class="ft6p59">Dim objRoom As CRoomEl </span></div>
<div class=styleNavBarBot>
<table width="836" border="0" cellspacing="2">
  <tr></tr>
  <tr>
    <td width="118"><a href="http://www.purepage.com"><img src="./smalllogo.gif" width="118" height="46" border="0" alt="http://www.purepage.com"></a></td>
    <td></td>
  </tr>
</table>
</div>

</td></tr></table>

</body>
</html>
